home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / delpp / fig18-18.gif < prev    next >
Graphics Interchange Format  |  1996-11-19  |  12.1 KB  |  593x454  |  4-bit (10 colors)
   ocr: A abll OR B 1 Form1.Queryl SQL Demo Using the NOT IN phrase to see orders for all but 4 customers Run Custno OrderNo ItemsTotal SQL: Select CustNo, OrderNo, Itemslotal From Orders Where Custno 1356 1305 $3,065.00 NOT IN (1221, 1231,1351,1354) 1356 1005 $4,807.00 Order By CustNo 1356 1180 $3,640.0U 1356 1080 $9,634.00 1356 1072 $3,596.00 1356 1059 $2,150.00 1356 1105 $31,219.95 1356 1266 $6,935.00 1356 1280 $4,317.75 SOL12)/S0L13ASOL141/S0L15)S0L16/S0L17/S0L181/50L191/S0L20AJ/SOL21/AS0L2, 4